| AdEnroll |
| Logical Entity Name | AdEnroll |
| Default Table Name | AdEnroll |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| AdEnroll Columns |
| AdEnroll Primary and Unique Keys |
| Key Name | Key Type | Keys |
| AdEnroll_IDS_Shf_AttSt_Stu_Grd_SchSt_Rp_PrgVr_BlMth_Rs_SAP_Ctl_U_N_IDX | Index | SyCampusID, adShiftID, adAttStatID, SyStudentID, AdGradeLevelID, SySchoolStatusID, AmRepID, adProgramVersionID, SaBillingMethodID, AdReasonID, AdSapStatusID, AdCatalogYearID, AdEnrollID |
| AdEnroll_SyStudentId_SyCampusId_AdProgramVersionId_AdEnrollId_U_N_IDX | Index | SyStudentID, SyCampusID, adProgramVersionID, AdEnrollID |
| AdEnroll_adProVerID_SyCamID_SaBilMetId_SySchStaId_CreReq_HouReq_AdShiId_DatBil_ExpStaDat_GraDat_AdEnrID_U_N_IDX | Index | adProgramVersionID, SyCampusID, SaBillingMethodID, SySchoolStatusID, CreditsReq, HoursReq, adShiftID, DateBilled, ExpStartDate, GradDate, AdEnrollID |
| AdEnroll_AdPrgrmVrsnId_SyCmpsID_SySchlSttsId_AdnrllId_SyStdntId_StrtDt_GrdDt_Stnm_U_N_IDX | Index | adProgramVersionID, SyCampusID, SySchoolStatusID, AdEnrollID, SyStudentID, StartDate, GradDate, StuNum |
| AdEnroll_AdEnrollID_U_C_IDX | PrimaryKey | AdEnrollID |
| AdEnroll_SyCampusID_SaBillingMethodID_AdEnrollID_U_IDX | Index | SyCampusID, SaBillingMethodID, AdEnrollID |
| Uk_AdEnrollLinkedSAPEnrollID_AdEnrollAdEnrollID | Index | LinkedSAPEnrollId, AdEnrollID |
| AdEnroll Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdCatalogYear | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AdCatalogYearID_AdCatalogYear_AdCatalogYearID | AdCatalogYearID | NO | YES | ||
| AdProgram | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AdProgramID_AdProgram_AdProgramID | AdProgramID | NO | YES | ||
| AdProgramVersion | Non-Identifying | One To Zero or More | FK_AdEnroll_adProgramVersionID_AdProgramVersion_AdProgramVersionID | adProgramVersionID | NO | YES | ||
| AdStartDate | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AdStartDateID_AdStartDate_AdStartDateID | AdStartDateID | NO | YES | ||
| AmApplicantType | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AmApplicantTypeID_AmApplicantType_AmApplicantTypeID | AmApplicantTypeID | NO | YES | ||
| syState | Non-Identifying | One To Zero or More | FK_AdEnroll_IPEDSState_syState_code | IPEDSState | NO | YES | ||
| AdEnroll | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_LinkedAdEnrollId_AdEnrollId | LinkedSAPEnrollId | NO | YES | ||
| SySchoolStatus | Non-Identifying | One To Zero or More | FK_AdEnroll_SySchoolStatusID_SySchoolStatus_SySchoolStatusID | SySchoolStatusID | NO | YES | ||
| syStudent | Non-Identifying | One To Zero or More | FK_AdEnroll_SyStudentID_syStudent_SyStudentID | SyStudentID | NO | YES |
| Child Relationships: |
| AdEnroll Check Constraints |
| Check Constraint Name | CheckConstraint |
| Chk_AdEnroll_GradDate | ([Applicant] = 1 or [Applicant] = 0 and [GradDate] is not null) |
| AdEnroll Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group |
| AdEnroll Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.StudentEnrollmentPeriod |
NO | |||
| Physical (Microsoft SQL Server) dbo.AdEnroll |
NO |
| AdEnroll Where Used - Submodel Usage |
| AdEnroll Data Movement Rules |
| Name | Type | Rule Text/Value |